create table employee(
	employee_no number,
	employee_name varchar2(30),
	employee_password varchar2(50),
	employee_department varchar2(40),
	employee_yn varchar2(10),
	employee_register varchar2(20),
	employee_hp varchar2(30),
	employee_date DATE,
	constraint  employee_pk primary key(employee_no)
)

drop table employee

drop sequence employee_no

create sequence employee_no


insert into employee values(employee_no.nextval,
'홍길동','1','인사','Y','11111111111111','01023230232',sysdate);

insert into employee values(employee_no.nextval,
'공돌이','2','작업자','N','12111111111111','01023230232',sysdate);


purge recyclebin